Best Practices-Relational Database Service (MySQL) - 天翼云

Relational Database Service (MySQL)

Updates &Notices

【Change】 Discontinuation of Object Storage Backup Type of MySQL on eSurfing Cloud HK2 from June 13, 2025

Introduction

What is a Relational Database？

Product Features

Product Advantages

Overview of Product Features

Instance Description

Typical Applications

Constraints and Restrictions

Relationship with Other Services

Explanation of Terminology

Billing Instructions

Product Fees

MySQL Single Instance

MySQL Primary/Standby Instances

MySQL Read-Only Instances

Billing Mode

Annual/Monthly Package

Billing as Per Use

Backup Billing Rules

Change of Billing Mode

Product Renewing and Unsubscribing

Expiration and Arrears

Quick Start

Operation Guide

Introduction of Instance Connection Mode

Connecting MySQL Instance Through the Intranet

Step 1: Create an instance

Step 2: Set the security group rules

Step 3: Connect the MySQL instance through the Intranet

Connecting MySQL Instance Through the Internet

Step 1: Create an instance

Step II: Configuring Security Group Rules

Step III: Binding the EIP

Step IV: Connecting to a MySQL Instance

Example: Purchasing and Connecting to a MySQL Instance

User Guide

Overview of Usage Rules

Instance Usage Rules

Database Usage Rules

Instance Management

Modifying the Instance Name

Modifying the Instance Password

Restarting an Instance

Parameter Settings

Modifying the Data Replication Mode

Specification Scaling

Upgrading the Database Minor Kernel Version

Master-Slave Switching

Creating Read-only

Storage Space Scaling

Backup space Scaling

Automatic Storage Space Scaling

Automatic Performance Scaling

Enabling/Disabling Instance Release Protection

Setting the Maintainable Time Period

Series Upgrading

Instance Recycle Bin

Read-only Instance

Brief Introduction to Read-only Instances

Creating Read-only Instances

Backup and Recovery

Introduction to Backup Restoration Function

Editing a Backup Policy

Creating a Manual Backup

High-Frequency Physical Backup

Deleting a Manual Backup

Restoring Schemes

Restoring an Instance from Full Backup Files

Restoring Instance Data to a Specified Time Point

Instance Overwriting Restoration

Using a Single Table in a Single Database for Restoration

Restoring from Physical Backup Files to a Self-Built Database

Local Binary Log Settings

Parameter Management

Introduction to Parameter Groups

Creating a Parameter Group

Copying a Parameter Group

Modifying Parameter Group

Deleting a Parameter Group

Comparing Parameter Groups

Restoring a Parameter Group

Applying a Parameter Group

Viewing Parameter Group Application Records

Event Management

Connecting to an Instance

Connecting to an Instance Through a General MySQL Command Line Client

Connecting to a MySQL Instance Through JDBC

Connecting to a MySQL Instance Through a Graphic User Interface

Account Management

Creating a Database User

Resetting the Account Password

Modifying Account Permissions

Deleting an Account

Custom Password Policy

Log Management

Viewing Error Logs

Viewing Slow Logs

Enabling SQL Audit Logs

Intercepting SQL

Tag Management

Task Center

Deleting a Task

Monitoring and Alarms

Supported Monitoring Indicators

Configuring Custom Alarm Rules

Setting Indicator Inspection

Setting Monitoring Frequency

Viewing Monitoring Indicators

Account and Security

Resetting Account Password and Root Permissions

Configuring SSL Data Encryption

Access Management

Binding and Unbinding the EIP

Modifying the Database Port

Downloading an SSL CA Certificate

Configuring an SSL CA Certificate for Accessing a MySQL Instance

Configuring Security Group Rules

Configuring the IP Trustlist

Database Management

Creating a Database

Deleting a Database

Bidirectional Synchronization

Bidirectional Synchronization between MySQL Instances

Read-Only Instance

Introduction to Read-Only Instances

Creating a Read-Only Instance

Data Migration

Migrating Data to MySQL Using mysqldump

Migrating MySQL Data from Other Cloud Databases

Migrating MySQL Data across eSurfing Cloud Accounts

Importing and Exporting Data with CSV Files, TXT Files, or SQL Scripts

Best Practices

MySQL Usage Specification Recommendations

Naming Criterion

Design Rules for Databases or Tables

Database Index Design Rules

Development and Use Specifications

MySQL Index Optimization Recommendations

Recommendations

Using MySQL to Build a Cross-AZ Disaster Recovery Instance

Realization Principle

Creating a Cross-AZ Disaster Recovery Instance

Setting utf8mb4 Character Set to Support Comprehensive Character Display

Configuring the Character Set of MySQL Instance

Configuring the Character Set of MySQL Instance

Unlocking Database Potential: Improving Data Service Capabilities by Matching MySQL and DRDS

Realization Principle

Creating a MySQL Instance

Read/Write Separation

Performance Tuning

Locating the Causes for High CPU Usage of RDS for MySQL and Providing Solutions

Maximum IOPS Supported by RDS for MySQL

Solutions for High Memory Usage of RDS for MySQL

Improving Query Speed of RDS for MySQL

Parameter Tuning Recommendations for RDS for MySQL

Determining the Issues of RDS for MySQL Slow SQL

Insufficient Disk Space for RDS for MySQL

Resolving Database Operation Failures Caused by Metadata Locks on RDS for MySQL

Resolving High I/O for RDS for MySQL

Parameter Optimization Recommendations

Important Parameters

Recommendation of Typical Parameter Combinations

FAQ

Management Class

Instance Host Resource Management

Database Indicator Monitoring

MySQL Instance Scaling and Specification Changing

MySQL Instance Log Management

Products

Product Consultation

Instance Stopping, Unsubscription, Freezing, Releasing, and Deletion

MySQL Read-Only Instance and Read/Write Separation

Database Accounts and Permissions

Database Engines and Storage Media

Operation Issues

Database Instance Connection

Database Backup and Restoration

RDS for MySQL Parameter Modification Description

MySQL Instance Version Upgrade

Other Class

Network Security Management

Database Migration

Client Installation and Use

Security White Paper

Security White Paper

Performance White Paper

Overview of Performance Testing

Performance Overview

Indicator Description

Testing Method

Test Environment

MySQL 5.7 Test Results

MySQL 8.0 Test Results

API Reference

Calling the API

Constructing a Request

Related Agreements

eSurfing Cloud Relational Database Service Agreement

Troubleshooting

Connection Class

What should I do if the SSL connection failes due to inconsistent client TLS version and MySQL version?

What should I do if a database cannot be connected to using the root account?

What should I do if an error message "connect established slowly" is reported on the client due to a slow connection on MySQL?

What should I do if the login fails after the authentication_string field is changed to display the password for the MySQL database?

Backup Restoration

What should I do if the backup fails due to DDL operations during the backup?

What are the precautions for exporting large tables through mysqldump?

How do I use mysqldump?

Primary/Standby Replication

What should I do if an error is reported when Canal parses Binlogs?

How primary/standby replication of MySQL work?

MySQL Primary/Standby Replication Delay Scenarios and Solutions

Automatic Recovery after Extended Primary/Standby Replication Delay

Performance Resource Class

High CPU Caused by Full Table Scanning

SQL Execution Lagging after Field Addition to a MySQL Table

Error 1461 Reported by a MySQL Database

Slow SQL Execution due to Data Migration

Other Usage Issues

Changing the AUTO_INCREMENT Value

How do I add tables to MySQL and assign values to table fields?

What should I do if the value of AUTO_INCREMENT exceeds the maximum value for this field in the table?

How does MySQL monitor the storage space?

How do I understand the value and increment of AUTO_INCREMENT in a MySQL table?

How do I view SQL audit log storage in MySQL?

Help Center Relational Database Service (MySQL) Best Practices

Overview
MySQL Usage Specification Recommendations
MySQL Index Optimization Recommendations
Using MySQL to Build a Cross-AZ Disaster Recovery Instance
Setting utf8mb4 Character Set to Support Comprehensive Character Display
Unlocking Database Potential: Improving Data Service Capabilities by Matching MySQL and DRDS
Performance Tuning
Parameter Optimization Recommendations